if exists (select null from sys.procedures where name = 'sp_new_product_profile')
	drop procedure sp_new_product_profile;
go

create procedure sp_new_product_profile
	@title varchar(200),
	@id int output
as
begin
	set nocount on;
	
	insert into product_profiles(title) values(@title);
	set @id = scope_identity();
end;
go

grant execute on sp_new_product_profile to prg;